1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
7 ?>
8 <?php
9 require_once('session1.php');
10 ?>
11 <?php
12 $id = $_GET['id'];
13 $select = "SELECT * FROM
14 studentstable WHERE admission_number='$id'";
15 $result = mysqli_fetch_array(mysqli_query($conn,$select));
16 $qry=mysqli_query($conn,$select);
17 if($qry)
18 {
19 while($rec = mysqli_fetch_array($qry)){
20 $sirname = "$rec[sirname]";
21 $firstname = "$rec[firstname]";
22 $lastname = "$rec[lastname]";
23 $gender = "$rec[gender]";
24 $mobile = "$rec[mobile]";
25 $email = "$rec[email]";
26 $address = "$rec[address]";
27 $zipcode = "$rec[zipcode]";
28 $course_id = "$rec[course_id]";
29 }}
30 ?>
31
32 <?php
33 SESSION_START();
34 ?>
35 <!DOCTYPE html>
36 <html>
37
38 <head>
39 <meta charset="utf-8">
40 <meta name="viewport" content="width=device-width, initial-scale=1.0">
41 <title>school management system</title>
42 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
43 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
44 <link href="assets/css/loader.css" rel="stylesheet" />
45 <script src="assets/js/canvasjs.min.js"></script>
46 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
47 <script src="assets/js/jquery-3.2.1.js"></script>
48
49 <script type="text/javascript">
50 function sum(){
51 var first_number = parseInt(document.getElementById("a").value);
52 var second_number = parseInt(document.getElementById("b").value);
53 var final =((first_number + second_number)/90)*100;
54 var result=Math.round(final);
55 document.getElementById("english").value = result;
56 }
57 </script>
58 <script type="text/javascript">
59 function sum2(){
60 var first_number = parseInt(document.getElementById("c").value);
61 var second_number = parseInt(document.getElementById("d").value);
62 var final =((first_number + second_number)/90)*100;
63 var result=Math.round(final);
64
65 document.getElementById("kiswahili").value = result;
66 }
67 </script>
68 <!--*****************calculating average marks*********************-->
69 <script type="text/javascript">
70 function final(){
71 var a = parseInt(document.getElementById("a").value);
72 var b = parseInt(document.getElementById("b").value);
73 var c = parseInt(document.getElementById("c").value);
74 var d = parseInt(document.getElementById("d").value);
75 var e = parseInt(document.getElementById("e").value);
76 var f = parseInt(document.getElementById("f").value);
77 var g = parseInt(document.getElementById("g").value);
78 var h = parseInt(document.getElementById("h").value);
79 var i = parseInt(document.getElementById("i").value);
80 var j = parseInt(document.getElementById("j").value);
81
82
83 //var number_of_subjects = parseInt(document.getElementById("h").value);
84
85 var final =((a + b + c + d + e + f+ g + h + i + j)/10);
86 var result=Math.round(final);
87
88 document.getElementById("average").value = result;
89 }
90 </script>
91
92
93
94 </head>
95
96 <body >
97 <!--end of heading section-->
98 <ul class="nav navbar-right top-nav">
99 <div class="dropdown">
100 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
101 <?php
102 //Check to see if the user is logged in.if not redirect user to the loging page.
103
104 if(isset($_SESSION['fname']))
105 {
106 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
107 }else{
108 echo "<script type='text/javascript'>
109 alert( 'You must Log in to use the system');
110 </script>";
111 echo "<script>
112 window.location = 'index.php'
113 </script>";
114 }
115 ?>
116 <span class="caret"></span></button>
117 <ul class="dropdown-menu">
118 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
119 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
120 <li class="divider"></li>
121 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
122 </ul>
123 </div>
124 </ul>
125 <!--************************************************-->
126 <div style="
127 font-family:Nyala, Arial;
128 text-align: left;
129 background-color: #526F35;
130 padding: 20px;
131 color:white;
132 width: 100%;
133 height: 150px;">
134 <!--This codes to load the image loader-->
135 <div id="loading">
136 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
137 </div>
138 <!--this is the heading section-->
139 <h2>
140 <?php
141 $sql="SELECT * FROM companyinfo";
142 $result=mysqli_query($db,$sql) or die("error getting data");
143 $num_rows=mysqli_num_rows($result);
144 while($row=mysqli_fetch_array($result))
145 {
146 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
147 $cname = $row['cname'];
148 $cemail = $row['cemail'];
149 $ccontact = $row['ccontact'];
150 $clocation = $row['clocation'];
151 }?>
152 <?php
153 echo $cname;
154 ?>
155
156 <div style="float:right; font-size:20px;text-align:right;">
157
158 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
159 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
160 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
161
162 </div>
163 </h2>
164 </div>
165 <!--end of heading section-->
166
167 <div>
168 <ul class="nav nav-tabs">
169 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
170 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
171 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
172 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
173 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
174 <li class="active"><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
175 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
176 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
177 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
178 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
179
180 </ul>
181 <div class="tab-content">
182 <div class="tab-pane active" role="tabpanel" id="tab-1">
183
184 <p>
185 <div class="table-responsive" >
186 <!--****************************************************************************-->
187 <div class="container" style="width:100%">
188
189 <ul class="nav nav-tabs">
190 <li ><a href="markstep1.php">Choose Class <img src="assets/img/new.png"> </a></li>
191
192 <li class="active"><a href="markstep3.php">Enter Marks<img src="assets/img/view2.png"></a></li>
193
194
195
196
197 <li><a href="markstep7.php">Print Transcript<img src="assets/img/print.png"> </a></li>
198 </ul>
199 <br>
200
201 </div>
202
203 <!--*************************************************************************************************************************-->
204 <div class="container-fluid">
205 <div class="row">
206 <div class="col-lg-6 col-lg-offset-3">
207 <div class="panel panel-primary">
208 <div class="panel-heading">Marks</div>
209 <!-- /.panel-heading -->
210 <div class="panel-body">
211 <div class="table">
212
213
214 <form action="markstep3.php" method="POST" enctype="multipart/form-data">
215 <div style="float:left; position:relative">
216 <h4><font color="green">Marks Entry</font></h4>
217 <table>
218 <tr>
219 <td><label>Student</label></td>
220 <td>
221 <select name="admission_number" class="form-control browser-default" id="admission_number">
222 <option value="" disabled="" <?php echo empty($id) ? "selected" : '' ?>> Select Here</option>
223 <?php
224 $students = mysqli_query($conn,"SELECT *,concat(firstname,' ',lastname) as name FROM studentstable order by concat(firstname,' ',lastname) asc ");
225 while($row=mysqli_fetch_assoc($students)):
226 ?>
227 <option value="<?php echo $row['admission_number'] ?>" data-course='<?php echo $row['course_id'] ?>' <?php echo !empty($id) && $id == $row['admission_number'] ? "selected" : '' ?>><?php echo ucwords($row['name']) ?></option>
228 <?php endwhile; ?>
229 </select>
230 <input type="hidden" name="course_id" value="<?php echo $course_id?>" class="form-control">
231 </td>
232 <tr/>
233 <tr>
234 <td><label>Term</label></td>
235 <td><select class="form-control" name="term">
236 <?php
237 include('connect.php');
238 $sql1="SELECT * FROM term";
239 $records1=mysqli_query($db,$sql1);
240 while($row=mysqli_fetch_array($records1))
241 {
242 echo "<option>".$row['termname']."</option>";
243
244 }
245 ?></select></td>
246 <td><label>Year</label></td>
247 <?php
248 // set start and end year range
249 $yearArray = range(2016, 2050);
250 ?>
251 <!-- displaying the dropdown list -->
252 <td> <select name="year" class="form-control">
253 <?php
254 foreach ($yearArray as $year) {
255 // if you want to select a particular year
256 $selected = ($year == 2018) ? 'selected' : '';
257 echo '<option '.$selected.' value="'.$year.'">'.$year.'</option>';
258 }
259 ?> </select></td> </tr><tr>
260
261 <td> <label> Exam Series</label></td>
262 <td> <select name="exam_series" class="form-control">
263 <option>End Term</option>
264 </select></td> </tr></table>
265
266 </div>
267
268 <div style="float:left; position:relative">
269 <h4><font color="green">Subjects</font></h4>
270
271 <table><tr>
272 <td><label>FBM
273 <input type="number" name="a" id="a" class="form-control" onkeyup="final()" max="100" >
274 </td>
275 <td><label>R_SERVICE
276 <input type="number" name="b" id="b" class="form-control" onkeyup="final()" max="100" >
277 </td></tr>
278
279 <tr>
280 <td><label>CT/PB
281 <input type="number" name="c" id="c" class="form-control" onkeyup="final()" max="100" >
282 </td>
283 <td><label>FOOD_SCIENCE
284 <input type="number" name="d" id="d" class="form-control" onkeyup="final()" max="100" >
285 </td></tr>
286
287 <tr>
288 <td><label>FUNDAMENTALS
289 <input type="number" name="e" id="e" class="form-control" onkeyup="final()" max="100" >
290 </td>
291 <td><label>FRONT_OFFICE
292 <input type="number" name="f" id="f" class="form-control" onkeyup="final()" max="100" >
293 </td></tr>
294
295 <tr>
296 <td><label>COMUNICATION_SKILLS
297 <input type="number" name="g" id="g" class="form-control" onkeyup="final()" max="100" >
298 </td>
299 <td><label>COSTING
300 <input type="number" name="h" id="h" class="form-control" onkeyup="final()" max="100" >
301 </td></tr>
302
303 <tr>
304 <td><label>HOUSEKEEPING
305 <input type="number" name="i" id="i" class="form-control" onkeyup="final()" max="100" >
306 </td>
307 <td><label>FOOD & BEVERAGE PRACTICAL
308 <input type="number" name="j" id="j" class="form-control" onkeyup="final()" max="100" >
309 </td>
310 </tr>
311
312 </table>
313 <label>Average</label>
314 <input type="text" name="average" id="average" class="form-control" placeholder="Average" ><br>
315 <div style="float:right; position:relative; clear:both;">
316
317 <input type="submit" name="register" value="Save Entry" class="btn btn-success" >
318 </div>
319 </form>
320 </div>
321 </div>
322 </div>
323 </div>
324 </div>
325 <!--****************************************************************************-->
326 <?php
327 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
328 if (isset($_POST['register'])){
329
330
331 /*$xx=$_POST['course_idz'];
332 $sql="SELECT * FROM course WHERE coursename='$xx'";
333 $user_query=mysqli_query($db,$sql) or die("error getting data");
334 while($row = mysqli_fetch_array($user_query)){
335 $course_id = $row['course_id'];}*/
336
337 $admission_number=$_POST['admission_number'];
338 $course_id=$_POST['course_id'];
339 $term=$_POST['term'];
340 $year=$_POST['year'];
341 $exam_series=$_POST['exam_series'];
342 $a=$_POST['a'];
343 $b=$_POST['b'];
344 $c=$_POST['c'];
345 $d=$_POST['d'];
346 $e=$_POST['e'];
347 $f=$_POST['f'];
348 $g=$_POST['g'];
349 $h=$_POST['h'];
350 $i=$_POST['i'];
351 $j=$_POST['j'];
352 $average=$_POST['average'];
353
354
355 mysqli_query($conn,"INSERT INTO
356 marks(
357 admission_number, course_id, term, year, exam_series, FBM, R_SERVICE, CT_PB, FOOD_SCIENCE, FUNDAMENTALS, FRONT_OFFICE, COMUNICATION_SKILLS, COSTING, HOUSEKEEPING, FB_PRACTICAL, average )
358 VALUES
359 ('$admission_number','$course_id','$term','$year','$exam_series','$a','$b','$c','$d','$e','$f','$g','$h','$i','$j'
360 ,'$average')") or die(mysqli_error());
361 ?>
362 <?php
363 $query="SELECT * FROM marks";
364 $records2=mysqli_query($db,$query);
365 while($rec=mysqli_fetch_array($records2))
366 {
367 $id = $rec['id'];
368 }?>
369
370 <script>
371
372 alert('Succsessfully Save.');
373 window.location = "markstep1.php?id=<?php echo $id;?>";
374 </script>
375 <?php }?>
376
377 <!--****************************************************************************-->
378
379
380 </div>
381 </p>
382
383
384 </div>
385
386 </div>
387 </div>
388
389 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
390 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
391 </div>
392 <script src="assets/js/jquery.min.js"></script>
393 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
394 <script src="assets/js/affix.js"></script>
395 <script src="assets/js/alert.js"></script>
396 <script src="assets/js/alert1.js"></script>
397 <script src="assets/js/bootstrap.js"></script>
398 <script src="assets/js/bootstrap.min.js"></script>
399 <script src="assets/js/bootstrap-datepicker.js"></script>
400 <script src="assets/js/bootstrap-wysihtml5.js"></script>
401 <script src="assets/js/button.js"></script>
402 <script src="assets/js/carousel.js"></script>
403 <script src="assets/js/chosen.jquery.min.js"></script>
404 <script src="assets/js/ckeditor.js"></script>
405 <script src="assets/js/collapse.js"></script>
406 <script src="assets/js/color.js"></script>
407 <script src="assets/js/dropdown.js"></script>
408 <script src="assets/js/DT_bootstrap.js"></script>
409 <script src="assets/js/dynamic.js"></script>
410 <script src="assets/js/ie-emulation-modes-warning.js"></script>
411 <script src="assets/js/jquery.dataTables.js"></script>
412 <script src="assets/js/jquery.dataTables.min.js"></script>
413 <script src="assets/js/jquery.dialog.js"></script>
414 <script src="assets/js/jquery.hoverdir.js"></script>
415 <script src="assets/js/jquery.jgrowl.js"></script>
416 <script src="assets/js/jquery.knob.js"></script>
417 <script src="assets/js/jquery.uniform.min.js"></script>
418 <script src="assets/js/jquery-1.8.3.min.js"></script>
419 <script src="assets/js/jquery-1.9.1.js"></script>
420 <script src="assets/js/jquery-1.9.1.min.js"></script>
421 <script src="assets/js/jquery-1.10.2.js"></script>
422 <script src="assets/js/jquery-1.11.0.js"></script>
423 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
424 <script src="assets/js/jquery-ui-1.10.3.js"></script>
425 <script src="assets/js/modal.js"></script>
426 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
427 <script src="assets/js/myjquery.js"></script>
428 <script src="assets/js/myjquery1.js"></script>
429 <script src="assets/js/npm.js"></script>
430 <script src="assets/js/popover.js"></script>
431 <script src="assets/js/profile.js"></script>
432 <script src="assets/js/raphael-min.js"></script>
433 <script src="assets/js/sb-admin-2.js"></script>
434 <script src="assets/js/scripts.js"></script>
435 <script src="assets/js/scrollspy.js"></script>
436 <script src="assets/js/tab.js"></script>
437 <script src="assets/js/tooltip.js"></script>
438 <script src="assets/js/transition.js"></script>
439 <script src="assets/js/wysihtml5-0.3.0.js"></script>
440 <script language="javascript" type="text/javascript">
441 $(window).load(function()
442 {
443 $('#loading').hide();
444 $('#admission_number').change(function(){
445 var id = $(this).val()
446 var course_id = $('#admission_number option[value="'+id+'"]').attr('data-course')
447 $('[name="course_id"]').val(course_id)
448 })
449 if('<?php echo !empty($id) ?>' == 1)
450 $('#admission_number').trigger('change')
451 });
452 </script>
453 </body>
454
455 </html>
